Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	368
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	51.8 KiB
Average record size in memory	144.0 B

Variable types

Numeric	15
Categorical	2

Alerts

`start_date` has a high cardinality: 368 distinct values	High cardinality
`end_date` has a high cardinality: 368 distinct values	High cardinality
`TOTAL SPECIMENS` is highly correlated with `TOTAL A` and 5 other fields	High correlation
`TOTAL A` is highly correlated with `TOTAL SPECIMENS` and 5 other fields	High correlation
`TOTAL B` is highly correlated with `TOTAL A` and 3 other fields	High correlation
`PERCENT POSITIVE` is highly correlated with `TOTAL SPECIMENS` and 4 other fields	High correlation
`PERCENT A` is highly correlated with `TOTAL SPECIMENS` and 4 other fields	High correlation
`PERCENT B` is highly correlated with `TOTAL A` and 3 other fields	High correlation
`ILITOTAL` is highly correlated with `TOTAL SPECIMENS` and 3 other fields	High correlation
`NUM. OF PROVIDERS` is highly correlated with `TOTAL SPECIMENS` and 2 other fields	High correlation
`TOTAL PATIENTS` is highly correlated with `TOTAL SPECIMENS` and 2 other fields	High correlation
`TOTAL SPECIMENS` is highly correlated with `TOTAL A` and 5 other fields	High correlation
`TOTAL A` is highly correlated with `TOTAL SPECIMENS` and 4 other fields	High correlation
`TOTAL B` is highly correlated with `TOTAL A` and 2 other fields	High correlation
`PERCENT POSITIVE` is highly correlated with `TOTAL SPECIMENS` and 4 other fields	High correlation
`PERCENT A` is highly correlated with `TOTAL SPECIMENS` and 2 other fields	High correlation
`PERCENT B` is highly correlated with `TOTAL B` and 1 other fields	High correlation
`ILITOTAL` is highly correlated with `TOTAL SPECIMENS` and 3 other fields	High correlation
`NUM. OF PROVIDERS` is highly correlated with `TOTAL SPECIMENS` and 2 other fields	High correlation
`TOTAL PATIENTS` is highly correlated with `TOTAL SPECIMENS` and 2 other fields	High correlation
`TOTAL SPECIMENS` is highly correlated with `TOTAL A` and 1 other fields	High correlation
`TOTAL A` is highly correlated with `TOTAL SPECIMENS` and 3 other fields	High correlation
`TOTAL B` is highly correlated with `TOTAL A` and 3 other fields	High correlation
`PERCENT POSITIVE` is highly correlated with `TOTAL A` and 3 other fields	High correlation
`PERCENT A` is highly correlated with `TOTAL A` and 2 other fields	High correlation
`PERCENT B` is highly correlated with `TOTAL B` and 1 other fields	High correlation
`ILITOTAL` is highly correlated with `TOTAL SPECIMENS` and 2 other fields	High correlation
`NUM. OF PROVIDERS` is highly correlated with `ILITOTAL` and 1 other fields	High correlation
`TOTAL PATIENTS` is highly correlated with `ILITOTAL` and 1 other fields	High correlation
`TOTAL SPECIMENS` is highly correlated with `TOTAL A` and 9 other fields	High correlation
`TOTAL A` is highly correlated with `TOTAL SPECIMENS` and 7 other fields	High correlation
`TOTAL B` is highly correlated with `TOTAL A` and 4 other fields	High correlation
`PERCENT POSITIVE` is highly correlated with `TOTAL SPECIMENS` and 7 other fields	High correlation
`PERCENT A` is highly correlated with `TOTAL SPECIMENS` and 7 other fields	High correlation
`PERCENT B` is highly correlated with `TOTAL A` and 6 other fields	High correlation
`start_year` is highly correlated with `TOTAL SPECIMENS` and 3 other fields	High correlation
`start_month` is highly correlated with `TOTAL SPECIMENS` and 5 other fields	High correlation
`start_day` is highly correlated with `end_day`	High correlation
`end_year` is highly correlated with `TOTAL SPECIMENS` and 3 other fields	High correlation
`end_month` is highly correlated with `TOTAL SPECIMENS` and 5 other fields	High correlation
`end_day` is highly correlated with `start_day`	High correlation
`ILITOTAL` is highly correlated with `TOTAL SPECIMENS` and 7 other fields	High correlation
`NUM. OF PROVIDERS` is highly correlated with `TOTAL SPECIMENS` and 4 other fields	High correlation
`TOTAL PATIENTS` is highly correlated with `TOTAL SPECIMENS` and 4 other fields	High correlation
`start_date` is uniformly distributed	Uniform
`end_date` is uniformly distributed	Uniform
`start_day` is uniformly distributed	Uniform
`end_day` is uniformly distributed	Uniform
`start_date` has unique values	Unique
`end_date` has unique values	Unique
`TOTAL A` has 113 (30.7%) zeros	Zeros
`TOTAL B` has 181 (49.2%) zeros	Zeros
`PERCENT POSITIVE` has 97 (26.4%) zeros	Zeros
`PERCENT A` has 113 (30.7%) zeros	Zeros
`PERCENT B` has 181 (49.2%) zeros	Zeros

Reproduction

Analysis started	2022-12-20 00:28:49.912091
Analysis finished	2022-12-20 00:29:13.163883
Duration	23.25 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

TOTAL SPECIMENS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	326
Distinct (%)	88.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	817.1222826

Minimum	48
Maximum	3303
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	48
5-th percentile	91.05
Q1	295.5
median	623
Q3	1146.5
95-th percentile	2193.55
Maximum	3303
Range	3255
Interquartile range (IQR)	851

Descriptive statistics

Standard deviation	656.3662364
Coefficient of variation (CV)	0.8032656193
Kurtosis	0.5265617833
Mean	817.1222826
Median Absolute Deviation (MAD)	396.5
Skewness	1.058313414
Sum	300701
Variance	430816.6362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
319	3	0.8%
959	3	0.8%
727	2	0.5%
81	2	0.5%
148	2	0.5%
439	2	0.5%
887	2	0.5%
1093	2	0.5%
966	2	0.5%
719	2	0.5%
Other values (316)	346	94.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
48	1	0.3%
58	1	0.3%
59	1	0.3%
60	1	0.3%
61	1	0.3%
63	1	0.3%
65	1	0.3%
67	1	0.3%
69	1	0.3%
70	1	0.3%

Value	Count	Frequency (%)
3303	1	0.3%
2873	1	0.3%
2632	1	0.3%
2573	1	0.3%
2555	1	0.3%
2512	1	0.3%
2467	1	0.3%
2459	1	0.3%
2447	1	0.3%
2444	1	0.3%

TOTAL A
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	117
Distinct (%)	31.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.07608696

Minimum	0
Maximum	644
Zeros	113
Zeros (%)	30.7%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	40
95-th percentile	309.9
Maximum	644
Range	644
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	114.4104884
Coefficient of variation (CV)	1.970010282
Kurtosis	6.307044606
Mean	58.07608696
Median Absolute Deviation (MAD)	2
Skewness	2.479372058
Sum	21372
Variance	13089.75986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	113	30.7%
1	47	12.8%
2	25	6.8%
4	9	2.4%
5	8	2.2%
3	7	1.9%
8	6	1.6%
6	6	1.6%
10	5	1.4%
35	4	1.1%
Other values (107)	138	37.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	113	30.7%
1	47	12.8%
2	25	6.8%
3	7	1.9%
4	9	2.4%
5	8	2.2%
6	6	1.6%
7	4	1.1%
8	6	1.6%
9	1	0.3%

Value	Count	Frequency (%)
644	1	0.3%
641	1	0.3%
567	1	0.3%
496	1	0.3%
451	2	0.5%
434	1	0.3%
427	1	0.3%
413	2	0.5%
412	1	0.3%
389	1	0.3%

TOTAL B
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	72
Distinct (%)	19.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.4048913

Minimum	0
Maximum	569
Zeros	181
Zeros (%)	49.2%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	7
95-th percentile	126.85
Maximum	569
Range	569
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	71.49277647
Coefficient of variation (CV)	2.929444577
Kurtosis	27.79454376
Mean	24.4048913
Median Absolute Deviation (MAD)	1
Skewness	4.85945612
Sum	8981
Variance	5111.217088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	181	49.2%
1	46	12.5%
2	18	4.9%
3	13	3.5%
4	8	2.2%
5	6	1.6%
12	3	0.8%
6	3	0.8%
96	3	0.8%
8	3	0.8%
Other values (62)	84	22.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	181	49.2%
1	46	12.5%
2	18	4.9%
3	13	3.5%
4	8	2.2%
5	6	1.6%
6	3	0.8%
7	3	0.8%
8	3	0.8%
10	2	0.5%

Value	Count	Frequency (%)
569	1	0.3%
549	1	0.3%
520	1	0.3%
418	1	0.3%
379	1	0.3%
332	1	0.3%
301	1	0.3%
249	1	0.3%
248	1	0.3%
222	1	0.3%

PERCENT POSITIVE
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	235
Distinct (%)	63.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.242907609

Minimum	0
Maximum	40.45
Zeros	97
Zeros (%)	26.4%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1.05
Q3	8.885
95-th percentile	27.5195
Maximum	40.45
Range	40.45
Interquartile range (IQR)	8.885

Descriptive statistics

Standard deviation	9.606568369
Coefficient of variation (CV)	1.538797139
Kurtosis	1.651263697
Mean	6.242907609
Median Absolute Deviation (MAD)	1.05
Skewness	1.632342003
Sum	2297.39
Variance	92.28615583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	97	26.4%
0.68	4	1.1%
0.23	4	1.1%
0.09	4	1.1%
0.11	3	0.8%
0.35	3	0.8%
1.16	3	0.8%
0.99	2	0.5%
0.42	2	0.5%
0.33	2	0.5%
Other values (225)	244	66.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	97	26.4%
0.06	1	0.3%
0.09	4	1.1%
0.1	2	0.5%
0.11	3	0.8%
0.12	1	0.3%
0.13	2	0.5%
0.14	2	0.5%
0.15	1	0.3%
0.16	1	0.3%

Value	Count	Frequency (%)
40.45	1	0.3%
40.37	1	0.3%
38.93	1	0.3%
37.38	1	0.3%
36.61	1	0.3%
36.32	1	0.3%
33.94	1	0.3%
32.99	1	0.3%
32.74	1	0.3%
32.09	1	0.3%

PERCENT A
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	209
Distinct (%)	56.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.221820652

Minimum	0
Maximum	28.68
Zeros	113
Zeros (%)	30.7%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.68
Q3	4.985
95-th percentile	20.5865
Maximum	28.68
Range	28.68
Interquartile range (IQR)	4.985

Descriptive statistics

Standard deviation	6.908198123
Coefficient of variation (CV)	1.636307814
Kurtosis	2.301249295
Mean	4.221820652
Median Absolute Deviation (MAD)	0.68
Skewness	1.828786143
Sum	1553.63
Variance	47.72320131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	113	30.7%
0.68	5	1.4%
0.23	4	1.1%
0.2	4	1.1%
1.07	3	0.8%
0.66	3	0.8%
0.25	3	0.8%
0.42	3	0.8%
1.39	3	0.8%
0.14	3	0.8%
Other values (199)	224	60.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	113	30.7%
0.06	2	0.5%
0.09	1	0.3%
0.1	1	0.3%
0.11	2	0.5%
0.12	1	0.3%
0.13	1	0.3%
0.14	3	0.8%
0.15	2	0.5%
0.16	1	0.3%

Value	Count	Frequency (%)
28.68	1	0.3%
28.2	1	0.3%
26.91	1	0.3%
26.28	1	0.3%
26.21	1	0.3%
26.19	1	0.3%
26.12	1	0.3%
25.31	1	0.3%
24.91	1	0.3%
24.53	1	0.3%

PERCENT B
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	143
Distinct (%)	38.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.021168478

Minimum	0
Maximum	25.97
Zeros	181
Zeros (%)	49.2%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.05
Q3	1.1575
95-th percentile	11.7
Maximum	25.97
Range	25.97
Interquartile range (IQR)	1.1575

Descriptive statistics

Standard deviation	4.268316643
Coefficient of variation (CV)	2.111806457
Kurtosis	7.733676499
Mean	2.021168478
Median Absolute Deviation (MAD)	0.05
Skewness	2.709149112
Sum	743.79
Variance	18.21852697
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	181	49.2%
0.11	5	1.4%
0.09	5	1.4%
0.06	4	1.1%
0.43	3	0.8%
0.28	3	0.8%
0.08	3	0.8%
0.19	3	0.8%
0.46	3	0.8%
0.13	3	0.8%
Other values (133)	155	42.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	181	49.2%
0.03	1	0.3%
0.04	1	0.3%
0.05	2	0.5%
0.06	4	1.1%
0.07	3	0.8%
0.08	3	0.8%
0.09	5	1.4%
0.1	1	0.3%
0.11	5	1.4%

Value	Count	Frequency (%)
25.97	1	0.3%
23.06	1	0.3%
21.27	1	0.3%
20.7	1	0.3%
18.39	1	0.3%
17.89	1	0.3%
17.4	1	0.3%
15.82	1	0.3%
15.59	1	0.3%
14.27	1	0.3%

start_date
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	368
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

2015-10-04	1
2020-05-30	1
2020-08-01	1
2020-07-25	1
2020-07-18	1
Other values (363)	363

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	368 ?
Unique (%)	100.0%

Sample

1st row	2015-10-04
2nd row	2015-10-11
3rd row	2015-10-18
4th row	2015-10-25
5th row	2015-11-01

Common Values

Value	Count	Frequency (%)
2015-10-04	1	0.3%
2020-05-30	1	0.3%
2020-08-01	1	0.3%
2020-07-25	1	0.3%
2020-07-18	1	0.3%
2020-07-11	1	0.3%
2020-07-04	1	0.3%
2020-06-27	1	0.3%
2020-06-20	1	0.3%
2020-06-13	1	0.3%
Other values (358)	358	97.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-10-04	1	0.3%
2015-12-20	1	0.3%
2015-10-18	1	0.3%
2015-10-25	1	0.3%
2015-11-01	1	0.3%
2015-11-08	1	0.3%
2015-11-15	1	0.3%
2015-11-22	1	0.3%
2015-11-29	1	0.3%
2015-12-06	1	0.3%
Other values (358)	358	97.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

end_date
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	368
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

2015-10-10	1
2020-06-05	1
2020-08-07	1
2020-07-31	1
2020-07-24	1
Other values (363)	363

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	368 ?
Unique (%)	100.0%

Sample

1st row	2015-10-10
2nd row	2015-10-17
3rd row	2015-10-24
4th row	2015-10-31
5th row	2015-11-07

Common Values

Value	Count	Frequency (%)
2015-10-10	1	0.3%
2020-06-05	1	0.3%
2020-08-07	1	0.3%
2020-07-31	1	0.3%
2020-07-24	1	0.3%
2020-07-17	1	0.3%
2020-07-10	1	0.3%
2020-07-03	1	0.3%
2020-06-26	1	0.3%
2020-06-19	1	0.3%
Other values (358)	358	97.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-10-10	1	0.3%
2015-12-26	1	0.3%
2015-10-24	1	0.3%
2015-10-31	1	0.3%
2015-11-07	1	0.3%
2015-11-14	1	0.3%
2015-11-21	1	0.3%
2015-11-28	1	0.3%
2015-12-05	1	0.3%
2015-12-12	1	0.3%
Other values (358)	358	97.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

start_year
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.777174

Minimum	2015
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	2015
5-th percentile	2016
Q1	2017
median	2019
Q3	2021
95-th percentile	2022
Maximum	2022
Range	7
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.064180212
Coefficient of variation (CV)	0.001022490366
Kurtosis	-1.159109412
Mean	2018.777174
Median Absolute Deviation (MAD)	2
Skewness	-0.01638807909
Sum	742910
Variance	4.260839948
Monotonicity	Increasing

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2017	53	14.4%
2021	53	14.4%
2016	52	14.1%
2018	52	14.1%
2020	52	14.1%
2019	51	13.9%
2022	42	11.4%
2015	13	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2015	13	3.5%
2016	52	14.1%
2017	53	14.4%
2018	52	14.1%
2019	51	13.9%
2020	52	14.1%
2021	53	14.4%
2022	42	11.4%

Value	Count	Frequency (%)
2022	42	11.4%
2021	53	14.4%
2020	52	14.1%
2019	51	13.9%
2018	52	14.1%
2017	53	14.4%
2016	52	14.1%
2015	13	3.5%

start_month
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.508152174

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.460156847
Coefficient of variation (CV)	0.5316650186
Kurtosis	-1.214061342
Mean	6.508152174
Median Absolute Deviation (MAD)	3
Skewness	-0.0235240064
Sum	2395
Variance	11.9726854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
10	35	9.5%
1	33	9.0%
5	32	8.7%
7	32	8.7%
12	30	8.2%
4	30	8.2%
8	30	8.2%
9	30	8.2%
11	29	7.9%
2	29	7.9%
Other values (2)	58	15.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	33	9.0%
2	29	7.9%
3	29	7.9%
4	30	8.2%
5	32	8.7%
6	29	7.9%
7	32	8.7%
8	30	8.2%
9	30	8.2%
10	35	9.5%

Value	Count	Frequency (%)
12	30	8.2%
11	29	7.9%
10	35	9.5%
9	30	8.2%
8	30	8.2%
7	32	8.7%
6	29	7.9%
5	32	8.7%
4	30	8.2%
3	29	7.9%

start_day
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM

Distinct	31
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.63586957

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.800422104
Coefficient of variation (CV)	0.562835477
Kurtosis	-1.192104955
Mean	15.63586957
Median Absolute Deviation (MAD)	8
Skewness	0.01858304804
Sum	5754
Variance	77.44742921
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
4	14	3.8%
3	14	3.8%
24	14	3.8%
11	14	3.8%
10	14	3.8%
17	14	3.8%
18	14	3.8%
25	14	3.8%
7	13	3.5%
28	13	3.5%
Other values (21)	230	62.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12	3.3%
2	11	3.0%
3	14	3.8%
4	14	3.8%
5	11	3.0%
6	11	3.0%
7	13	3.5%
8	12	3.3%
9	10	2.7%
10	14	3.8%

Value	Count	Frequency (%)
31	8	2.2%
30	9	2.4%
29	11	3.0%
28	13	3.5%
27	11	3.0%
26	11	3.0%
25	14	3.8%
24	14	3.8%
23	9	2.4%
22	12	3.3%

end_year
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.790761

Minimum	2015
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	2015
5-th percentile	2016
Q1	2017
median	2019
Q3	2021
95-th percentile	2022
Maximum	2022
Range	7
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.063625937
Coefficient of variation (CV)	0.001022208927
Kurtosis	-1.164372418
Mean	2018.790761
Median Absolute Deviation (MAD)	2
Skewness	-0.01452027121
Sum	742915
Variance	4.258552008
Monotonicity	Increasing

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2016	53	14.4%
2021	53	14.4%
2017	52	14.1%
2018	52	14.1%
2019	52	14.1%
2020	51	13.9%
2022	43	11.7%
2015	12	3.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2015	12	3.3%
2016	53	14.4%
2017	52	14.1%
2018	52	14.1%
2019	52	14.1%
2020	51	13.9%
2021	53	14.4%
2022	43	11.7%

Value	Count	Frequency (%)
2022	43	11.7%
2021	53	14.4%
2020	51	13.9%
2019	52	14.1%
2018	52	14.1%
2017	52	14.1%
2016	53	14.4%
2015	12	3.3%

end_month
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.538043478

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.456805234
Coefficient of variation (CV)	0.5287216651
Kurtosis	-1.211414686
Mean	6.538043478
Median Absolute Deviation (MAD)	3
Skewness	-0.02520578192
Sum	2406
Variance	11.94950243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
10	35	9.5%
7	33	9.0%
1	32	8.7%
12	31	8.4%
4	31	8.4%
3	30	8.2%
5	30	8.2%
6	30	8.2%
9	30	8.2%
11	29	7.9%
Other values (2)	57	15.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	32	8.7%
2	28	7.6%
3	30	8.2%
4	31	8.4%
5	30	8.2%
6	30	8.2%
7	33	9.0%
8	29	7.9%
9	30	8.2%
10	35	9.5%

Value	Count	Frequency (%)
12	31	8.4%
11	29	7.9%
10	35	9.5%
9	30	8.2%
8	29	7.9%
7	33	9.0%
6	30	8.2%
5	30	8.2%
4	31	8.4%
3	30	8.2%

end_day
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM

Distinct	31
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.76902174

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.778436369
Coefficient of variation (CV)	0.55668871
Kurtosis	-1.184479305
Mean	15.76902174
Median Absolute Deviation (MAD)	7.5
Skewness	0.008256533131
Sum	5803
Variance	77.06094509
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
10	14	3.8%
9	14	3.8%
17	14	3.8%
16	14	3.8%
23	14	3.8%
24	14	3.8%
13	13	3.5%
27	13	3.5%
20	13	3.5%
6	13	3.5%
Other values (21)	232	63.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11	3.0%
2	13	3.5%
3	12	3.3%
4	11	3.0%
5	11	3.0%
6	13	3.5%
7	12	3.3%
8	11	3.0%
9	14	3.8%
10	14	3.8%

Value	Count	Frequency (%)
31	7	1.9%
30	13	3.5%
29	9	2.4%
28	12	3.3%
27	13	3.5%
26	11	3.0%
25	11	3.0%
24	14	3.8%
23	14	3.8%
22	10	2.7%

ILITOTAL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	323
Distinct (%)	87.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	901.3641304

Minimum	27
Maximum	6300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	27
5-th percentile	90.05
Q1	287.75
median	551
Q3	1118
95-th percentile	3242.1
Maximum	6300
Range	6273
Interquartile range (IQR)	830.25

Descriptive statistics

Standard deviation	1017.475734
Coefficient of variation (CV)	1.128817644
Kurtosis	5.901381464
Mean	901.3641304
Median Absolute Deviation (MAD)	325.5
Skewness	2.337895781
Sum	331702
Variance	1035256.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
177	4	1.1%
382	4	1.1%
210	3	0.8%
312	3	0.8%
599	3	0.8%
262	2	0.5%
92	2	0.5%
151	2	0.5%
198	2	0.5%
230	2	0.5%
Other values (313)	341	92.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
27	1	0.3%
55	1	0.3%
60	1	0.3%
64	1	0.3%
65	2	0.5%
69	1	0.3%
71	1	0.3%
72	1	0.3%
74	1	0.3%
77	1	0.3%

Value	Count	Frequency (%)
6300	1	0.3%
5122	1	0.3%
4986	1	0.3%
4812	1	0.3%
4636	1	0.3%
4460	1	0.3%
4384	1	0.3%
4158	1	0.3%
4138	1	0.3%
4130	1	0.3%

NUM. OF PROVIDERS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	72
Distinct (%)	19.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.29891304

Minimum	12
Maximum	186
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	12
5-th percentile	24
Q1	45
median	60
Q3	92
95-th percentile	184
Maximum	186
Range	174
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	44.77339614
Coefficient of variation (CV)	0.5868156485
Kurtosis	0.8316480511
Mean	76.29891304
Median Absolute Deviation (MAD)	21.5
Skewness	1.275595198
Sum	28078
Variance	2004.657002
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
58	25	6.8%
92	23	6.2%
45	17	4.6%
44	16	4.3%
186	16	4.3%
93	13	3.5%
42	12	3.3%
57	12	3.3%
184	11	3.0%
60	11	3.0%
Other values (62)	212	57.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12	1	0.3%
20	1	0.3%
22	5	1.4%
23	4	1.1%
24	9	2.4%
25	7	1.9%
26	3	0.8%
27	2	0.5%
28	5	1.4%
32	1	0.3%

Value	Count	Frequency (%)
186	16	4.3%
184	11	3.0%
182	3	0.8%
180	2	0.5%
168	3	0.8%
166	1	0.3%
162	1	0.3%
156	1	0.3%
154	2	0.5%
152	1	0.3%

TOTAL PATIENTS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	366
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58170.49457

Minimum	6273
Maximum	164848
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	6273
5-th percentile	18749.5
Q1	28108
median	51021
Q3	68488.5
95-th percentile	144038.8
Maximum	164848
Range	158575
Interquartile range (IQR)	40380.5

Descriptive statistics

Standard deviation	37139.78256
Coefficient of variation (CV)	0.6384642736
Kurtosis	0.731831206
Mean	58170.49457
Median Absolute Deviation (MAD)	20337
Skewness	1.244901681
Sum	21406742
Variance	1379363449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23405	2	0.5%
30624	2	0.5%
31716	1	0.3%
41221	1	0.3%
41044	1	0.3%
39665	1	0.3%
39712	1	0.3%
38766	1	0.3%
34622	1	0.3%
35078	1	0.3%
Other values (356)	356	96.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6273	1	0.3%
12278	1	0.3%
14963	1	0.3%
15234	1	0.3%
15456	1	0.3%
15527	1	0.3%
15610	1	0.3%
16483	1	0.3%
16698	1	0.3%
16912	1	0.3%

Value	Count	Frequency (%)
164848	1	0.3%
160036	1	0.3%
152132	1	0.3%
150592	1	0.3%
150590	1	0.3%
149618	1	0.3%
149526	1	0.3%
147948	1	0.3%
146840	1	0.3%
146580	1	0.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	TOTAL SPECIMENS	TOTAL A	TOTAL B	PERCENT POSITIVE	PERCENT A	PERCENT B	start_date	end_date	start_year	start_month	start_day	end_year	end_month	end_day	ILITOTAL	NUM. OF PROVIDERS	TOTAL PATIENTS
0	259	1	2	1.16	0.39	0.77	2015-10-04	2015-10-10	2015	10	04	2015	10	10	185	44	23405
1	256	1	1	0.78	0.39	0.39	2015-10-11	2015-10-17	2015	10	11	2015	10	17	134	43	20815
2	244	0	1	0.41	0.00	0.41	2015-10-18	2015-10-24	2015	10	18	2015	10	24	177	44	24135
3	231	0	1	0.43	0.00	0.43	2015-10-25	2015-10-31	2015	10	25	2015	10	31	142	41	24071
4	273	0	0	0.00	0.00	0.00	2015-11-01	2015-11-07	2015	11	01	2015	11	07	164	44	24554
5	218	1	1	0.92	0.46	0.46	2015-11-08	2015-11-14	2015	11	08	2015	11	14	165	45	24543
6	263	0	0	0.00	0.00	0.00	2015-11-15	2015-11-21	2015	11	15	2015	11	21	162	44	25102
7	287	2	0	0.70	0.70	0.00	2015-11-22	2015-11-28	2015	11	22	2015	11	28	147	42	16912
8	286	1	1	0.70	0.35	0.35	2015-11-29	2015-12-05	2015	11	29	2015	12	05	200	46	25220
9	303	0	3	0.99	0.00	0.99	2015-12-06	2015-12-12	2015	12	06	2015	12	12	202	46	24901

Last rows

	TOTAL SPECIMENS	TOTAL A	TOTAL B	PERCENT POSITIVE	PERCENT A	PERCENT B	start_date	end_date	start_year	start_month	start_day	end_year	end_month	end_day	ILITOTAL	NUM. OF PROVIDERS	TOTAL PATIENTS
358	1621	1	0	0.06	0.06	0.00	2022-08-14	2022-08-20	2022	08	14	2022	08	20	1088	146	133270
359	1504	3	0	0.20	0.20	0.00	2022-08-21	2022-08-27	2022	08	21	2022	08	27	1118	150	136460
360	1529	5	0	0.33	0.33	0.00	2022-08-28	2022-09-03	2022	08	28	2022	09	03	1042	150	135500
361	1567	7	0	0.45	0.45	0.00	2022-09-04	2022-09-10	2022	09	04	2022	09	10	1222	156	133664
362	1787	3	0	0.17	0.17	0.00	2022-09-11	2022-09-17	2022	09	11	2022	09	17	1656	154	146580
363	1891	13	0	0.69	0.69	0.00	2022-09-18	2022-09-24	2022	09	18	2022	09	24	2032	168	164848
364	1992	10	0	0.50	0.50	0.00	2022-09-25	2022-10-01	2022	09	25	2022	10	01	2226	168	160036
365	2362	15	0	0.64	0.64	0.00	2022-10-02	2022-10-08	2022	10	02	2022	10	08	1269	92	80301
366	2388	16	2	0.75	0.67	0.08	2022-10-09	2022-10-15	2022	10	09	2022	10	15	1411	94	81762
367	2332	25	1	1.11	1.07	0.04	2022-10-16	2022-10-22	2022	10	16	2022	10	22	1348	93	82281

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows